home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ftp.cs.arizona.edu
/
ftp.cs.arizona.edu.tar
/
ftp.cs.arizona.edu
/
tsql
/
doc
/
tsql.mail
/
000144_csj@iesd.auc.dk _Sun Jun 6 23:25:41 1993.msg
< prev
next >
Wrap
Internet Message Format
|
1996-01-31
|
5KB
Received: from iesd.auc.dk by optima.CS.Arizona.EDU (5.65c/15) via SMTP
id AA18342; Sun, 6 Jun 1993 14:26:58 MST
Received: from yellow.iesd.auc.dk by iesd.auc.dk with SMTP id AA00171
(5.65c8/IDA-1.5/MD for <tsql@cs.arizona.edu>); Sun, 6 Jun 1993 23:25:41 +0200
Date: Sun, 6 Jun 1993 23:25:41 +0200
From: "Christian S. Jensen" <csj@iesd.auc.dk>
Message-Id: <199306062125.AA00171@iesd.auc.dk>
To: tsql@cs.arizona.edu
Subject: TSQL Benchmark STATUS
**********************************************************************
** The TSQL Benchmark **
** Task 4--Benchmark Queries --- STATUS **
**********************************************************************
Dear colleague,
The preparation of the first version of the TSQL Benchmark was divided
into four tasks. The first three tasks---deciding on the benchmark
database schema and instance, and the taxonomy of benchmark
queries---have been accomplished. The last task, that of populating
the taxonomy with queries, is close to completion. Specifically, there
were thirty classes, and five queries were to be supplied for each
class. At this time, at total of twenty classes have been chosen by
volunteers, and only the following ten classes are still available for
contributors.
Classes Available
*****************
O1.S7 O1.S8 O1.S9 O1.S10
O2.S4 O2.S5 O2.S6 O2.S10
O3.S6 O3.S8
While time is short, contributors are still encouraged to choose one
or two classes (i.e., write 5 or 10 queries). All that do so will
become coauthors of the paper. If you are interested, but have
questions and need more information, please feel free to contact me
(csj@iesd.auc.dk).
Immediately following is a Latex document that may be used when
viewing queries. The document also provides additional explanation.
Note that this additional explanation is added here to explain the
categories and classes. Such explanation is not required in the
submitted queries.
Finally, contributors were also encouraged to write appendices with
comments and observations that may be useful in the continued work
with the TSQL benchmark. The firm deadline for receipt of such
appendices is noon on Wednesday, June 9.
Best regards,
Christian S. Jensen, editor
Aalborg University
csj@iesd.auc.dk
\documentstyle[11pt]{article}
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
% Latex template for queries
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
\addtolength{\textwidth}{1.485in} \setlength{\oddsidemargin}{.1in}
\setlength{\evensidemargin}{.1in} \addtolength{\topmargin}{-.85in}
\addtolength{\textheight}{1.8in}
\long\def\comment#1{}
\long\def\query#1#2#3{\begin{verse} {\bf Query \no} {#1} \end{verse}
\begin{verse} {\bf Answer:} {#2} \end{verse} \begin{verse} {\bf
Category:} {#3} \end{verse}}
\newcounter{qnumber}
\newcounter{rnumber}[subsection]
\newcounter{gnumber}[subsubsection]
\newcommand{\no}{\setcounter{qnumber}{\value{subsection}}
\setcounter{rnumber}{\value{subsubsection}}\protect\refstepcounter{gnumber}
Q \protect\theqnumber.\protect\thernumber.\protect\thegnumber:}
\begin{document}
\subsection{Example With Explanations}
\subsubsection{Class O1.S3 (Duration, Element, Computed)}
\query{Find the names of employees that have been in a department
named Toy for a shorter period than has DI.}
{``Ed'' and ``Edward.''}
{(Projected, None) / (Duration, Element, Computed) / (=, Constant)
(=, Constant)}
\noindent {\it The employee ED has been in a department named Toy
for a period which is shorter than that of DI. The categorization
is with respect to Figure 6. ``(Projected, None)'' indicates that
only part of the attributes of the argument relation are present
in the result and that there is no valid-time component. Next,
``(Duration, Element, Computed)'' indicates that a duration based
predicates is used on element-valued arguments which are both
derived from the valid-times of stored facts. Finally, ``(=,
Constant) (=, Constant)'' indicates that there are two
non-temporal selection predicates that test for equality of an
attribute value with a constant (i.e., the person must be DI and
the department must have name Toy).}
\query{Find the current name and department name for the persons which
made \$40K for a longer period than DI did.}
{``(Edward, Book).''}
{(Projected, None) / (Duration, Element, Computed) (Containment,
Event, Explicit) / (=, Constant)}
\noindent {\it In this query, there are two valid-time selection
based predicates. The one used for categorization compares the
duration of time when a person makes \$40K with the period of time
that DI makes \$40K. The other selects the name and department
that overlap with the current time of qualifying persons.}
\end{document}